import xlwings as xl
import sort_test

app = xl.App()
wb = app.books.open('employer.xlsx')
names = wb.sheets['Sheet1'].range('b3:c12').value
wb.close()
app.quit()

# print(type(names))
# print(names)
# bak_names = names.copy()
# names.sort(key=sort_test.degree_order_list_grace)
bak_names02 = sorted(names, key=sort_test.degree_order_list_grace)
for n in bak_names02:
    print(n)

print('原始表')
for n in names:
    print(n)